

import 'package:path/path.dart';
import 'package:sqflite/sqflite.dart';


class CreateTableSqls {
  //关系表语句


  //用户表语句
  static final String createTableSql_payAndBal = '''
    CREATE TABLE IF NOT EXISTS pay_bal (
    id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT UNIQUE, 
    consumptionObject TEXT, 
    classification TEXT,
    card INTEGER,
    total REAL,
    consumptionNum REAL,
    isPay BOOLEAN,
    imageStr TEXT, 
    updateTime TEXT
    );
    ''';

  Map<String, String> getAllTables() {
    Map<String, String> map = Map<String, String>();
    map['user'] = createTableSql_payAndBal;
    return map;
  }

}

